export const tableSqls : string[] = [
    `create table if not exists dept_output_plan
(
    id                     number null,
    planTime              date             not null,
    changeNum             bigint default 0 not null ,
    residue                bigint default 0 not null ,
    insertNum             bigint default 0 not null ,
    inputStaff            int    default 0 not null ,
    rotationStaff         int    default 0 not null ,
    lCottonNum           int    default 0 not null ,
    staffReceiveNum      int    default 0 not null ,
    pupaReceiveNum       int    default 0 not null ,
    sCottonNum           int    default 0 not null ,
    estimateTransformNum int    default 0 not null ,
    entireKillNum        int    default 0 not null ,
    estimateKillNum      int    default 0 not null ,
    remark                 varchar(255)     null,
    createBy              varchar(20)      null,
    createTime            datetime         null,
    updateBy              varchar(20)      null,
    updateTime            datetime         null,
    deptId                int              null,
    userId                int              null
)`,
    `create table if not exists type_round_sum
(
    id           number null,
    round        int          null ,
    bug_type     varchar(32)  null ,
    sum          bigint       null ,
    reload_day   date         not null ,
    remark       varchar(255) null ,
    updated_time datetime     null ,
    updated_by   varchar(32)  null ,
    create_time  datetime     null ,
    create_by    varchar(32)  null ,
    table_status char         null ,
    dept_id      int          null ,
    user_id      int          null 
)`,
    `create table if not exists bug_feeding
(
    id               number  null,
    tableType        varchar(32)   null,
    enterId          bigint           null ,
    yearsMonth       varchar(32)      null ,
    dateForDay      datetime         null ,
    roomId           bigint           null ,
    batchNumber      varchar(64)      null ,
    bugType          varchar(32)      null ,
    optionMonth      datetime         null ,
    round             int              null ,
    period           int null ,
    reloadDay        datetime         null ,
    nextReloadDay   datetime         null ,
    changeNum        bigint           null ,
    stiffNum         bigint           null ,
    roundStiff       int              null ,
    pupaNum          bigint           null ,
    roundPupa        int              null ,
    deathNum         bigint           null ,
    roundDeath       int              null ,
    killNum          bigint           null ,
    residue           bigint           null ,
    changeDeptId    bigint           null ,
    changeRoomId    bigint           null ,
    glBatchNumber   varchar(32)      null ,
    glChangeNum     bigint           null ,
    glStiffNum      bigint           null ,
    glRoundStiff    int              null ,
    glPupaNum       bigint           null ,
    glRoundPupa     int              null ,
    glKillNum       bigint           null ,
    glDeathNum      bigint           null ,
    glRoundDeath    int              null ,
    glResidue        bigint           null ,
    glChangeDeptId bigint           null ,
    glChangeRoomId bigint           null ,
    specialChange    int  default 0   null ,
    userId           bigint           null ,
    deptId           bigint           null ,
    tableStatus      char             null ,
    createTime       datetime         null ,
    createBy         varchar(32)      null ,
    updatedBy        varchar(32)      null ,
    updatedTime      datetime         null ,
    remark            varchar(255)     null ,
    leaderOpinion    varchar(255)     null ,
    glFlag           char default '0' null ,
    killFlag         char default '0' null,
    feedBatchNumber varchar(255) null
)`,
    `create table if not exists bug_entering
(
    id                 number null,
    uId           text     null,
    batchNumber        varchar(32)  null  ,
    bugType            varchar(10)  null  ,
    reloadingStyle     char         not null ,
    optionDate         datetime     null  ,
    nextReloadingDate datetime     null  ,
    sum                 bigint       null  ,
    roomId             bigint       null  ,
    digoutMonth        varchar(8)   null  ,
    digoutInfection    varchar(10)  null  ,
    userId             bigint       null  ,
    deptId             bigint       null  ,
    createBy           varchar(32)  null  ,
    tableStatus        char         null  ,
    createTime         datetime     null  ,
    updatedBy          varchar(32)  null  ,
    updatedTime        datetime     null  ,
    remark              varchar(255) null  ,
    leaderOpinion      varchar(255) null  ,
    userName      text null  ,
    roomName      text null  
)`,
    `create table if not exists user(
        id number not null,
        username text not null,
        password text not null,
        nickname text ,
        dept_id int ,
        dept_name text null,
        role text null
    )`,
    `create table if not exists msg(
    id           INT  primary key,
    content      text  null ,
    msgType     text         null ,
    sendId      int       not null ,
    targetId    int       not null ,
    contentId   int       null ,
    msgStatus   text      not null
)`,
    `create table if not exists localChange(
    id           Integer primary key AUTOINCREMENT , 
    targetId     text   null ,
    changeType   text         null ,
    targetType      int       not null ,
    changeTime   text       not null ,
    changeStatus   text      not null,
    userId  int null,
    unique (id)
)`,
    `create table if not exists room
(
    id          Integer primary key ,
    deptId      bigint       null ,
    userId      bigint       null ,
    roomName    varchar(32)  null ,
    tableStatus char         null ,
    createBy    varchar(32)  null ,
    createTime  datetime     null ,
    updatedBy   varchar(32)  null ,
    updatedTime datetime     null ,
    remark       varchar(255) null 
)`,
    `create table if not exists sys_dept
(
    deptId     Integer primary key,
    parentId   bigint      default 0   null ,
    ancestors   varchar(50) default ''  null ,
    deptName   varchar(30) default ''  null ,
    orderNum   int(4)      default 0   null ,
    leader      varchar(20)             null ,
    phone       varchar(11)             null ,
    email       varchar(50)             null ,
    status      char        default '0' null ,
    delFlag    char        default '0' null ,
    createBy   varchar(64) default ''  null ,
    createTime datetime                null ,
    updateBy   varchar(64) default ''  null ,
    updateTime datetime                null ,
    killFlag   char        default '0' null
)`,
    `
    create table if not exists day_report
(
    id              Integer primary key,
    qrChange       bigint       null ,
    yzChange       bigint       null ,
    stiffNum       bigint       null ,
    pupaNum        bigint       null ,
    deathNum       bigint       null ,
    onceKill       bigint       null ,
    ordinaryKill   bigint       null ,
    allKill        bigint       null ,
    changeDeptNum bigint       null ,
    specialChange  bigint       null ,
    qrInput        bigint       null ,
    yzInput        bigint       null ,
    glNum          bigint       null ,
    redBug         bigint       null ,
    residue         bigint       null ,
    userId         bigint       null ,
    deptId         bigint       null ,
    tableStatus    char         null ,
    createTime     datetime     null ,
    createBy       varchar(32)  null ,
    updatedBy      varchar(32)  null ,
    updatedTime    datetime     null ,
    remark          varchar(255) null 
)`
]
